package com.hrs.core.mapper;

import com.hrs.enity.db.SalaryScale;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hrs.enity.dto.SalaryViewDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
* @author 纱雾休比酱
* @description 针对表【t_salary_scale(薪酬标准表)】的数据库操作Mapper
* @createDate 2022-12-05 23:04:49
* @Entity com.hrs.enity.db.SalaryScale
*/
@Mapper
public interface SalaryScaleMapper extends BaseMapper<SalaryScale> {

    SalaryViewDto getSalaryById(@Param("id") Long id);

    List<SalaryViewDto> pageSalary(@Param("pageNum") Integer pageNum, @Param("pageSize") Integer pageSize,
                              @Param("idKey") String idKey , @Param("key") String key, @Param("begin")Date beginTime,
                              @Param("end") Date endTime,@Param("status") Integer status);

    Long totalPage(@Param("idKey") String idKey , @Param("key") String key, @Param("begin")Date beginTime,
                   @Param("end") Date endTime,@Param("status") Integer status);

    List<SalaryViewDto> listAll(@Param("status") Integer status);

}




